/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package sv.com.intesal.seguridad.sql;

/**
 *
 * @author JM
 */
public class SQLFormulario {

    public static final String insertFormulario = "INSERT INTO FORMULARIO(codigo_m,nombre_f,nombre_form_f)VALUES(?,?,?)";
    public static final String updateFormulario = "UPDATE FORMULARIO SET codigo_m=?,nombre_f=?,nombre_form_f=? where codigo_f=?";
    public static final String buscarFormularios = "SELECT * FROM FORMULARIO as f,MODULO as m where m.codigo_m=f.codigo_m order by nombre_m,nombre_f";
    public static final String buscarFormulario = "SELECT * FROM FORMULARIO as f,MODULO as m where m.codigo_m=f.codigo_m where codigo_f=?";
    public static final String getMax = "SELECT max(codigo_f) as max FROM FORMULARIO";
}
